insert overwrite table jms_dim.dim_tab_bulk_cargo_shift_base
select
id,
region,
region_code,
province,
province_code,
agent,
agent_code,
trans_shipment_center,
trans_shipment_center_code,
city,
city_code,
area,
area_code,
first_shift,
second_shift,
create_time,
create_by,
modify_time,
modify_by,
effective_start_time,
effective_end_time,
deliver_span_day,
deliver_over_time
from jms_ods.tab_bulk_cargo_shift
where dt = '{{ execution_date | cst_ds }}'